

2022-02-02 04:31:23.537197
SELECT DISTINCT supplier_id  
            FROM 0_subcontractor_invoices subi  
                JOIN 0_subcontractor_invoice_details subid ON 
                    subid.order_no = subi.order_no 
                JOIN 0_list_values lc  
                    ON lc.id = subid.category_id 
            WHERE subi.project_id ='10'                 
                AND lc.value_code IN ('RETENTION')

2022-02-02 04:31:23.539022
SELECT d.amount
            FROM 0_subcontractor_invoices i 
                JOIN 0_subcontractor_invoice_details d 
                    ON d.order_no = i.order_no 
                JOIN 0_list_values lc  
                    ON lc.id = d.category_id 
            WHERE i.project_id = '10' 
                AND i.supplier_id ='6' 
                AND lc.value_code IN ('RETENTION') ORDER BY i.ord_date 

2022-02-02 04:31:23.540463
SELECT d.amount
            FROM 0_subcontractor_invoices i 
                JOIN 0_subcontractor_invoice_details d 
                    ON d.order_no = i.order_no 
                JOIN 0_list_values lc  
                    ON lc.id = d.category_id 
            WHERE i.project_id = '10' 
                AND i.supplier_id ='4' 
                AND lc.value_code IN ('RETENTION') ORDER BY i.ord_date 

2022-02-02 04:31:23.541903
SELECT d.amount
            FROM 0_subcontractor_invoices i 
                JOIN 0_subcontractor_invoice_details d 
                    ON d.order_no = i.order_no 
                JOIN 0_list_values lc  
                    ON lc.id = d.category_id 
            WHERE i.project_id = '10' 
                AND i.supplier_id ='159' 
                AND lc.value_code IN ('RETENTION') ORDER BY i.ord_date 

2022-02-02 04:31:23.543251
SELECT d.amount
            FROM 0_subcontractor_invoices i 
                JOIN 0_subcontractor_invoice_details d 
                    ON d.order_no = i.order_no 
                JOIN 0_list_values lc  
                    ON lc.id = d.category_id 
            WHERE i.project_id = '10' 
                AND i.supplier_id ='158' 
                AND lc.value_code IN ('RETENTION') ORDER BY i.ord_date 
